UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptNe60wGFGAcfPy+a3EiPLCH8Ipfhu07tp1Ju3FIUas='
WHERE
key_id = '6f4ffb852bb0c0d50b312f984382f0460f5db94004e70b79fadc35a369d38b0c'
AND (
token = 'ptNe60wGFGAcfPy+a3EiPLCH8Ipfhu07tp1Ju3FIUas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)