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