UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E2VWAhntwAK81b/3T3py+80spiTvswl4206EfekpJBU='
WHERE
key_id = '585f12410c99c19b0a469fefb713b6dc270bfaa21ea81768035eaacc8e6318cf'
AND (
token = 'E2VWAhntwAK81b/3T3py+80spiTvswl4206EfekpJBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)