UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r3pKJLqL3yDYoq5U06S0tbogrLK/yGBGH6F88HZR04c='
WHERE
key_id = 'ac7a37ed3873bbbae4ee7cd70f7163e0a7783457beb694ac937ff90f7593aac2'
AND (
token = 'r3pKJLqL3yDYoq5U06S0tbogrLK/yGBGH6F88HZR04c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)