UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yFTmhBf9tgaN4B2kyCCHPOZTMoMyWWCnN05gCw+0ceQ='
WHERE
key_id = '0c2d712e299469e0bc1f97f35eace19c714d857e7605e65345ed8971269aebd0'
AND (
token = 'yFTmhBf9tgaN4B2kyCCHPOZTMoMyWWCnN05gCw+0ceQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)