UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8QYlozwWcnkhbaykoXOHlt8Qdf65ARHs2/DuE3n1Ws='
WHERE
key_id = '141695ab3563cea7dac1f4274549d3efecbf10ab9073947e79ffc9c26515cb9a'
AND (
token = 'v8QYlozwWcnkhbaykoXOHlt8Qdf65ARHs2/DuE3n1Ws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)