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