UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uPNFZh0U12jPg3/ECT1Tpve+cVVFVdWY+lHRhn+xg7g='
WHERE
key_id = '07a31591ade2b84965419722c668a9f49a837eb855b4f6c03bce86de67f9cad3'
AND (
token = 'uPNFZh0U12jPg3/ECT1Tpve+cVVFVdWY+lHRhn+xg7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)