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