UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFFe0okPoYIHT2galvilYPhW3KMBtQFHM245/xjQBVo='
WHERE
key_id = 'c67d0ee233dd5e3a62b39da1c1d12897f94026e2c63564f6670c6b8f93d782c4'
AND (
token = 'oFFe0okPoYIHT2galvilYPhW3KMBtQFHM245/xjQBVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)