UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+MDSnM8SJPEM8MAt9rTgj0rovcYCivgGBIdK/cw9FE='
WHERE
key_id = '3dbbc9b53e49b4d12898a5d29272290761794b2edb6f7c3c45df244028ee4647'
AND (
token = 'W+MDSnM8SJPEM8MAt9rTgj0rovcYCivgGBIdK/cw9FE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)