UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JoggGEvhyAYxMlAc6xAqwxMYfEivHVFYH9SZ7eY8aNw='
WHERE
key_id = 'a031d1b32c0fd5e66a918dfd920e3029d0cf1aa0a6b551a4c02c70d4b82436fc'
AND (
token = 'JoggGEvhyAYxMlAc6xAqwxMYfEivHVFYH9SZ7eY8aNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)