UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/DKB2JqgdOK5ykTk0OVHWXtvwKE7YDBAhtnw4k3p1Rk='
WHERE
key_id = 'ce0275683d5a8c73d226d77667de0c47aa9fcbf03f613d03592d5e33a49180ad'
AND (
token = '/DKB2JqgdOK5ykTk0OVHWXtvwKE7YDBAhtnw4k3p1Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)