UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CVKpi9/47qXZKPsquQLnPWogCoNttVsynMuzMgCiTXY='
WHERE
key_id = '7b587e95070d0d23639b3ea8ae6d310659215960f874f45cc6498caad5e5ef18'
AND (
token = 'CVKpi9/47qXZKPsquQLnPWogCoNttVsynMuzMgCiTXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)