UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AIG4t4ktb2WglOjhLVMMgFw1R05fCSn/U/PL9XjotLw='
WHERE
key_id = 'f9a7da81bc239dde859b5a223cfa941f2bc9b716c47131e95983b6e3cd85cf9b'
AND (
token = 'AIG4t4ktb2WglOjhLVMMgFw1R05fCSn/U/PL9XjotLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)