UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'elzKl7NAnZAXf6Negv0K29A2KoTRJLseWQlK4+eS+ew='
WHERE
key_id = 'd6c1c82f2f0765cef1aaddf975e83047e5de62c65752edc61086395e261e9655'
AND (
token = 'elzKl7NAnZAXf6Negv0K29A2KoTRJLseWQlK4+eS+ew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)