UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4jsgXmnkfpKJC08CCnwcYEJc8I9lg1dnOAv0gjxpbw='
WHERE
key_id = '0d56a6a18e91839265f430db6f54cf1a8899415bf8910c013cd7455caa2e1360'
AND (
token = 'A4jsgXmnkfpKJC08CCnwcYEJc8I9lg1dnOAv0gjxpbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)