UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oDSBlZQISAtzLiBY1Vk51Cqz6xhQE8jaE5XTiOf0AC4='
WHERE
key_id = 'c74e07f2b2420cb95440685bb8cd91f5119a049df7e8e61915fad695743c266e'
AND (
token = 'oDSBlZQISAtzLiBY1Vk51Cqz6xhQE8jaE5XTiOf0AC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)