UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+a6Nnb4vFY2jhsFZemXxXJy5PEMdJ7pf38FpSUcckvE='
WHERE
key_id = 'debf2e34e873b0cdf2167901dbaca23a1c6efa3873192ec0039ca5e0f1758861'
AND (
token = '+a6Nnb4vFY2jhsFZemXxXJy5PEMdJ7pf38FpSUcckvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)