UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29DMsOUiYudYfUsiclD7vdB56t8K22V11udeY/Gw+I8='
WHERE
key_id = 'e3541aed240db081e72687cca3fce592794f0916991e63ff5d8273c856cac5bf'
AND (
token = '29DMsOUiYudYfUsiclD7vdB56t8K22V11udeY/Gw+I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)