UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7/Y87866NGh5RfCl8pxlKouvtWalHsDuM9v4GLf8ow='
WHERE
key_id = '67f266847810b45f1e31b3c7ef06f87c7ad882b7691934a3f9c69fce2f63e049'
AND (
token = 'G7/Y87866NGh5RfCl8pxlKouvtWalHsDuM9v4GLf8ow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)