UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gxltZY8DcS8bwnodcLkGtWDqTnUWlqpNSUl3Z9hbt8='
WHERE
key_id = 'd81a152af8e4f52f1fc3f47ab10a69524b7443ef18c7390c6908e84ba6779870'
AND (
token = '4gxltZY8DcS8bwnodcLkGtWDqTnUWlqpNSUl3Z9hbt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)