UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N3f53yux4zxCON+VwRVIb5J0Efta4VO2gWyzmKqrTc='
WHERE
key_id = '3ecb3a0a59b03f23261a68257ba44d7401666df30feaed45fc847d8b33b4ac59'
AND (
token = '7N3f53yux4zxCON+VwRVIb5J0Efta4VO2gWyzmKqrTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)