UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9U58BEE1dEUQcpLdgivkFpQKNygeEu0lSvcbrzE6SA8='
WHERE
key_id = '6364d7824f3aee7ae875e4bb28d6bfc017c502bd4ec4685b0838630abf4b6230'
AND (
token = '9U58BEE1dEUQcpLdgivkFpQKNygeEu0lSvcbrzE6SA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)