UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZTsaXJFB/6rdV3pI0JpyUF1MpJ2UVIb2SLMVppyuX8='
WHERE
key_id = 'ada65d1df4f39524d33c292af500629b9b13b8f3cb26dfa67ddc2a2c69a4ccda'
AND (
token = 'xZTsaXJFB/6rdV3pI0JpyUF1MpJ2UVIb2SLMVppyuX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)