UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oj2RXnNa4N2q7g2rG2AS8uO2CIzkAzzyGbSxDP2klC0='
WHERE
key_id = '8f271ba398dc39e25ea79bbf15236980061b4a5244fc16b458522672592721ad'
AND (
token = 'Oj2RXnNa4N2q7g2rG2AS8uO2CIzkAzzyGbSxDP2klC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)