UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RrSPnVctreih7KVeKENOndiLhkD+wqi7GPMLf1I2cj8='
WHERE
key_id = 'ba1308c6c516772f53fcc266736a31284dfad7c85539991a9a462011b9acf5a4'
AND (
token = 'RrSPnVctreih7KVeKENOndiLhkD+wqi7GPMLf1I2cj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)