UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tjP/gJs3Gq88VaWfouJBm07Vp77m3hOlGHHwKpkOpTw='
WHERE
key_id = 'c3bb47e06e376f5c4d1d38af6af311f51edafc8640b06ade3b06403c4a79a322'
AND (
token = 'tjP/gJs3Gq88VaWfouJBm07Vp77m3hOlGHHwKpkOpTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)