UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N9Sb5sP6Ze3gnJ2+pbSRxBMTAiQAuLgwFQ0xaKvvDa0='
WHERE
key_id = 'e55cc96a66d69acc6e7c5c17a2296dc26a5d6ef53d033854f3efdd1de9f0a154'
AND (
token = 'N9Sb5sP6Ze3gnJ2+pbSRxBMTAiQAuLgwFQ0xaKvvDa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)