UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vd4QVSKWZ2lETZxsj74Q+0JNAj8B3S7CrOn3P2HhtuE='
WHERE
key_id = '6a594dc1f99ae3cacdf510acf3c1f0d65f0831c1e26ecc70e12f812ffeca925c'
AND (
token = 'Vd4QVSKWZ2lETZxsj74Q+0JNAj8B3S7CrOn3P2HhtuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)