UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CxXp5RoUwjOJLkgPw0Kst7NzQOhhsupx8rPxnsNaYFk='
WHERE
key_id = '557a398381d84919f7b3032b4e18ddef8d4d89909feeca788bc03389991d1604'
AND (
token = 'CxXp5RoUwjOJLkgPw0Kst7NzQOhhsupx8rPxnsNaYFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)