UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MpshZL3vJvsj6DkGrINg1aL2mARuRgdsiTWgRFFKQDY='
WHERE
key_id = '9e266e79ee7c54b5dcc659eb32f75223144b88b03795b1555e91a94c17c0f563'
AND (
token = 'MpshZL3vJvsj6DkGrINg1aL2mARuRgdsiTWgRFFKQDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)