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