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