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