UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZcieG6En3msFOMKFGcbOH7D40SkrwADk4vL+BUnWS8='
WHERE
key_id = '92db7c71807e65e206adfe8eb9c7da03da239d8a1bf717f052563030bf71eb68'
AND (
token = 'pZcieG6En3msFOMKFGcbOH7D40SkrwADk4vL+BUnWS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)