UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGVstV3yssUXWiE+SaIG8yB9ZxMwelGJzK8t5PMt4Fc='
WHERE
key_id = 'ed6326cd42d15600d2be5833918dd9ce651c5eabd15192287f172549f5232f7d'
AND (
token = 'cGVstV3yssUXWiE+SaIG8yB9ZxMwelGJzK8t5PMt4Fc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)