UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2h371lt5r/1qVPI/aTxBOMYkTBFHpiN3++8N2+aBGzU='
WHERE
key_id = '31e54655a1e8d0bc09875c938322cd8e273646aa09cf943621a41ee1b06df839'
AND (
token = '2h371lt5r/1qVPI/aTxBOMYkTBFHpiN3++8N2+aBGzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)