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