UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oBxk6y4/1NgeI2ykAts7H2KrYiRGSQO2hiWxlN7GaV0='
WHERE
key_id = 'd4ed453cb3f86dc3f63c1b0bd4a1d7d3c59b410590670b48207e6a91466ef96a'
AND (
token = 'oBxk6y4/1NgeI2ykAts7H2KrYiRGSQO2hiWxlN7GaV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)