UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzSX8JwP4xbpLQ/oMzaG9A2PJ+282pE5jybRK/G0zSc='
WHERE
key_id = '477176a762d4624630b7222a11c89d0f7a2d30f1f477d682cab2b87ea253aeab'
AND (
token = 'zzSX8JwP4xbpLQ/oMzaG9A2PJ+282pE5jybRK/G0zSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)