UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJdE5XhhVP5l6fnVg/vospJuE0BdI3M7GCkrkYiME5g='
WHERE
key_id = 'cc86e2ecc877d6765b5d59f7cac410c7edd46ad3952a9ea5fb4a95d170b678ac'
AND (
token = 'VJdE5XhhVP5l6fnVg/vospJuE0BdI3M7GCkrkYiME5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)