UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCpqZEwBPiCzPnR42h1UI3iLM5Av8dT81/zKoDFWy3I='
WHERE
key_id = 'b7b3b9c9cbaf4ead782f70dc17c75e9d3d745fcdfe1c0bc2fb46a61d46a9713c'
AND (
token = 'pCpqZEwBPiCzPnR42h1UI3iLM5Av8dT81/zKoDFWy3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)