UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lri/KHstwGlJkarYGz1KAWBu1KTk741F7UZBLkR3XbU='
WHERE
key_id = 'f42cd3ea0f01a95fb24e0fc8f77b3745d8564369fbba508820c1fdb84e858ff9'
AND (
token = 'lri/KHstwGlJkarYGz1KAWBu1KTk741F7UZBLkR3XbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)