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